UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4QlCSfdD7woZ/XbBNMkL8lgbZXOeNPVpLR7DI9RAeBw='
WHERE
key_id = 'fd35c5e71a288e119aeb311c6d93a4a80f0d0991ca94c4a643ded29ecd8025cd'
AND (
token = '4QlCSfdD7woZ/XbBNMkL8lgbZXOeNPVpLR7DI9RAeBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)