UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0lAkE6Kate3Peqw+rCA/+FgurixzSk2oeN1VKk0J80='
WHERE
key_id = '3ba274a1a36acd91e46f534c31b0bef371f9815c80d25609ef0603d007279965'
AND (
token = 'X0lAkE6Kate3Peqw+rCA/+FgurixzSk2oeN1VKk0J80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)