UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JDxGB7PrDCNYL7Paero2Oz1mOJoRJVVeB38M3COyBrY='
WHERE
key_id = '5bc2be25810cb40d5838ae85961b955d01b6968b9d73df4eb57103c1171c7995'
AND (
token = 'JDxGB7PrDCNYL7Paero2Oz1mOJoRJVVeB38M3COyBrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)