UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Otp5kCvGfuL/CbBrhfW91Rp8DVGAMW71m6UQqE4hBds='
WHERE
key_id = '2a4d199336083b6dbb60df5e474466099bd47d1452792f0d9056626d0e6ba278'
AND (
token = 'Otp5kCvGfuL/CbBrhfW91Rp8DVGAMW71m6UQqE4hBds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)