UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w4FUwu1amshdlkUpbtZSy1J6jIT6QSYVf/9fX2M9r50='
WHERE
key_id = 'ce4de6a4bf79c2c56e2a3a32351021ee916d928e715414fb4d6427288364b6b0'
AND (
token = 'w4FUwu1amshdlkUpbtZSy1J6jIT6QSYVf/9fX2M9r50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)