UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TuBINOb2MUkAEPCdsCxEw0G1iS9plviUUrARIO7egSg='
WHERE
key_id = '59c157f4dee0122b0c6d053fa7bd54ce28dabf2d4b3854e765b58a6f6dbd9cbf'
AND (
token = 'TuBINOb2MUkAEPCdsCxEw0G1iS9plviUUrARIO7egSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)