UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kDBRWCSVg2CtOQFTknbLuyleT33TWRmj+gb4g8AbWY0='
WHERE
key_id = '1a1ececd885f59eb35f6da412551ffee3bbcf9bc0163e916a6b8ccf87b7b36bf'
AND (
token = 'kDBRWCSVg2CtOQFTknbLuyleT33TWRmj+gb4g8AbWY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)