UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZaYImR6us526aRlEbWmdeDKywa7K0wGUpIJ/Z4Gk6M='
WHERE
key_id = '12d153b5898ba2ad2849df9385e35b632b0b70142138d34ef9587c2b042afdfa'
AND (
token = '0ZaYImR6us526aRlEbWmdeDKywa7K0wGUpIJ/Z4Gk6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)