UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnHvtII+Ks2u1aydIYXP7IE8mhLYQIGISgez3crhXfc='
WHERE
key_id = '93ba64604095486a32ca6711c041ddd9344799a76f80bb67e251c394ce0e5ef0'
AND (
token = 'pnHvtII+Ks2u1aydIYXP7IE8mhLYQIGISgez3crhXfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)