UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oDyqBASal8YA5IaBsVWnh8yL9NsY6dTvUuyDtdXCUOY='
WHERE
key_id = '04f55918aacbdde571c503868d09b80930a2766ff36c3d1f97b6f65502f7f371'
AND (
token = 'oDyqBASal8YA5IaBsVWnh8yL9NsY6dTvUuyDtdXCUOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)