UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'szA0EcFtIycetOCn+6ublB7j05xtqP/ifSRpNysIPMg='
WHERE
key_id = 'e30fa7fb29e7a06f5f058bc2d131f54af10cc2e1bb941df2830b365eb3b4a688'
AND (
token = 'szA0EcFtIycetOCn+6ublB7j05xtqP/ifSRpNysIPMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)