UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8//UN32UWl5cJMcYmKB3GMtsX3OslBVNMHuyeiBUom8='
WHERE
key_id = 'a3d10c3a0020cd8fddac659bf45fe2fa4569993e5df01fa26e5f7605b0ee9fdb'
AND (
token = '8//UN32UWl5cJMcYmKB3GMtsX3OslBVNMHuyeiBUom8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)