UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yplSngjJnYShMm9hbqjo51aDf8hXhn6X+9pri/e6ZH4='
WHERE
key_id = 'e18b737dad9be08125684a5c167e269da33a9acf4309c4c0e32bd68d13beaf9b'
AND (
token = 'yplSngjJnYShMm9hbqjo51aDf8hXhn6X+9pri/e6ZH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)