UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgQWgg4by132I7El6XkGP7//ytQk2h7Bnwk1WE5MVdY='
WHERE
key_id = 'b9b74fddaa40be2dc21e3919b89b12eb904ef279ba3d20439c7e6edf3b6514d2'
AND (
token = 'pgQWgg4by132I7El6XkGP7//ytQk2h7Bnwk1WE5MVdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)