UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hmO9v97fnYl6dqDxqy6NuSPW6zkUBoA4vET1MBbocFk='
WHERE
key_id = 'd393113e7ea603bc4c7deaac2de48a0a06338783dc6df443df850d88fb65c554'
AND (
token = 'hmO9v97fnYl6dqDxqy6NuSPW6zkUBoA4vET1MBbocFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)