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