UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zyWzYrxAXDG7CJr3Hxch77ILjIQX0acgGrY9HEMYnnA='
WHERE
key_id = '4e412a419f72663ec484f09d8aa18563bb27ae5b8d0c29c0edef0d4c008e4555'
AND (
token = 'zyWzYrxAXDG7CJr3Hxch77ILjIQX0acgGrY9HEMYnnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)