UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IgAiPLuqSLyGHoX7Pa04+2atH/3SQroE4c18S+cGnL0='
WHERE
key_id = '9d4ff60f234a22e05dc70e4675bf1d102ea47039a289dfb3ca9b677db09b160a'
AND (
token = 'IgAiPLuqSLyGHoX7Pa04+2atH/3SQroE4c18S+cGnL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)