UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tiWUrS2rzPfTBiS7gt5enrX1x2sXCQ5g9ifz7Xpeftc='
WHERE
key_id = '8ab5bf70333d37c7fadcccf2469dd31d221eb6ed286f0930ef0f850278c90102'
AND (
token = 'tiWUrS2rzPfTBiS7gt5enrX1x2sXCQ5g9ifz7Xpeftc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)