UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1c39rFmzTkBTTGVGZPi2QQ0YtEw3yoHySaphIas17w='
WHERE
key_id = 'c18a91722d1e5328c0266b768e36b802e881acbfd93ba93764b717831cbeef35'
AND (
token = 'P1c39rFmzTkBTTGVGZPi2QQ0YtEw3yoHySaphIas17w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)