UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ffVgGg2DpnbpMafTJp4Llp454KiF32ngFX+kSgck1XU='
WHERE
key_id = 'dcc2f89adebc3319fb4bf322a00f112ac9f97b0b1c60d87962f32a3ba611a9b5'
AND (
token = 'ffVgGg2DpnbpMafTJp4Llp454KiF32ngFX+kSgck1XU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)