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