UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47GchH25Syhpkb1ixMvH8//aVqd3TU+S912Z4J+rmnc='
WHERE
key_id = 'accbc0f60140b3ae09a7bdc45528e8919312c23ae6354fc7b385ed90a46df618'
AND (
token = '47GchH25Syhpkb1ixMvH8//aVqd3TU+S912Z4J+rmnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)