UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pXGpQAKgjuDX744u/bov2QkNocYcgz5eEIUOKCtX7w='
WHERE
key_id = 'b4bd6c679dd5de6f9a43c5ed660665178efa0bec2f58f7baaeb76d0f16d89c06'
AND (
token = '0pXGpQAKgjuDX744u/bov2QkNocYcgz5eEIUOKCtX7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)