UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pO/yKmi4kblqJRJId0DsHX/1ohBL4ZkGYIcfb3xQZg='
WHERE
key_id = 'e830beccbb48da0070bed79ecb483b9139f59c83d668be6c0be6ccffee23fe67'
AND (
token = '0pO/yKmi4kblqJRJId0DsHX/1ohBL4ZkGYIcfb3xQZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)