UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBK1Uh90s8EUE6EnMZ86VatE4S6vkPcyIz5GeSI47dA='
WHERE
key_id = '49a5e4c656e62af35544036c9965ebf4ff8d5e429e237a672a0df04996070a55'
AND (
token = 'zBK1Uh90s8EUE6EnMZ86VatE4S6vkPcyIz5GeSI47dA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)