UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x/7sa0nttlb17rprN4SmxqZs0wBvWXLWkbAY7aqQ0u8='
WHERE
key_id = 'adedf541d7822a4c50b3a723b704123186ea67d6fcbe93c129accd6b91c1be3a'
AND (
token = 'x/7sa0nttlb17rprN4SmxqZs0wBvWXLWkbAY7aqQ0u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)