UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gE6HsgHftzViQYY43rM2kWJVKKuGtb5dLbmE2J6jPkA='
WHERE
key_id = '735750a0614a4e9829fc84b0908c9c1058860f2ccac274801c9ad49e2eb832ae'
AND (
token = 'gE6HsgHftzViQYY43rM2kWJVKKuGtb5dLbmE2J6jPkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)